prepare("insert into damages(department,ddate,item_category,item_name,measure,quantity,dsc,admin) values(:a,:b,:c,:d,:e,:f,:g,:h)") ; $query->bindparam(":a",$_SESSION['sdept']) ; $query->bindparam(":b",$_SESSION['sdate']) ; $query->bindparam(":c",$cat) ; $query->bindparam(":d",$names) ; $query->bindparam(":e",$mes) ; $query->bindparam(":f",$qty) ; $query->bindparam(":g",$ds) ; $query->bindparam(":h",$adm) ; if($query->execute()) $mos = "Damages Submitted Successfully" ; } //} ?> DAMAGES

Dashboard

ENTER DAMAGES

MEASURE
prepare("select * from damages where department = '$_SESSION[sdept]'") ; $gtcat->execute() ; $count = 0 ; while($row = $gtcat->fetch(pdo::FETCH_ASSOC)) { $count++ ; echo "" ; echo "" ; echo "" ; echo "" ; echo "" ; echo "" ; echo "" ; ?> " ; } ?>
SN DATE ITEM CATEGORY ITEM NAME MEASURE QUANTITY ACTIONS
".$count."".$row['ddate']."".$row['item_category']."".$row['item_name']."".$row['measure']."".$row['quantity']."DELETE